

*------------------------------------------------------------------------------**------------------------------------------------------------------------------*
* import data ING *
*------------------------------------------------------------------------------**------------------------------------------------------------------------------*

set excelxlsxlargefile on
import excel "data/source/ING_2018_Wave_20_v2.xlsx", clear firstrow


duplicates report SERIAL // unique

rename P1 age
rename P2 gender
rename P3 employment
rename P4 status
rename P5 hh_size
rename P6 education
rename P7 hh_netincomeeuro

rename Q20_a crypto_heardof
rename Q20_b crypto_own
rename Q20_c crypto_expectown


rename Q21_1 crypto_future_spending
rename Q21_2 crypto_future_investment
rename Q21_3 crypto_future_valueincrease

rename Q23 crypto_investadvice

keep SERIAL Quota1 Quota2 WeightPerCountry WeightEurope ///
		Country Region age gender employment status hh_size education hh_netincomeeuro ///
		crypto_*

sort SERIAL
save "data/working/data_ING.dta", replace 

 


